UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YCsrrIbO0KbU7lkq/Fvkx3esVfqND2gOYThSIkB9Xpo='
WHERE
key_id = '7645c314c481b70f9f1616ad906c253476e13d724ea759acd553d90d80542f7c'
AND (
token = 'YCsrrIbO0KbU7lkq/Fvkx3esVfqND2gOYThSIkB9Xpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)