UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H8F2TV9OgnScpiRb5ManF87UGKkSscZiPtBjoqP0eI8='
WHERE
key_id = '84e461cef8bc65ee751f6d75c4fd8356b298f6c51bf2efaabfb66e1789852896'
AND (
token = 'H8F2TV9OgnScpiRb5ManF87UGKkSscZiPtBjoqP0eI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)