UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J7Ucng8SWCOJpRETzIelVLoxYpmc51eKvutKrVZcFtE='
WHERE
key_id = 'e93296d02fd5b9a43525d6040eca82f9e34ad7c5823f9bbd04a5d1f3c22d525e'
AND (
token = 'J7Ucng8SWCOJpRETzIelVLoxYpmc51eKvutKrVZcFtE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)