UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9kXEP1WuDeRlELjN4aD7lNt36JyUGZ5IlLxRZfIkb40='
WHERE
key_id = '3def8b7c5584dba7869b31beb8e48f96838a58cab1905a778d37a4c1ae8acc1b'
AND (
token = '9kXEP1WuDeRlELjN4aD7lNt36JyUGZ5IlLxRZfIkb40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)