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