UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'efSx6B5MtN4QFaUjG7QhOvE2GnOyAXPn24L2AFS19Qg='
WHERE
key_id = '6f1e3fae09584eaea67a9bfe34f016d7d1ee1d4c5afc831626f07d394de7ca74'
AND (
token = 'efSx6B5MtN4QFaUjG7QhOvE2GnOyAXPn24L2AFS19Qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)