UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KY8zSY8LNKibC3LBoyTkReeuSxe4Mh2PyLSCuqTqfpA='
WHERE
key_id = 'fd6281e374012d0e7a7cfb27e731e33ddcd5e00b8b9378d475dd23f7f87d4c08'
AND (
token = 'KY8zSY8LNKibC3LBoyTkReeuSxe4Mh2PyLSCuqTqfpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)