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