UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aFl7jt9/pQ8MK87aisZeiG2hcRcEudjTz/P61VbW6Nc='
WHERE
key_id = 'f42e45fb7deea62c0f492ede62fa59e5640071bb60af9fbe01131eec304022e5'
AND (
token = 'aFl7jt9/pQ8MK87aisZeiG2hcRcEudjTz/P61VbW6Nc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)