UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gYCrcAc/5SA1EkL8eIorIKevY6T1tpIwT3ANCuMoOts='
WHERE
key_id = 'd727667b9189e2a241de4c3717a5cb740b80b20335cf8cb25c6369c6f6c34e87'
AND (
token = 'gYCrcAc/5SA1EkL8eIorIKevY6T1tpIwT3ANCuMoOts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)