UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yZ9d8kOAdreQLnwMOWyfR7fuc50iN1ywLhHy8TXte8k='
WHERE
key_id = '594a8b6ceb4aac1249417a457413ce51a20008fbae66a08e45a3fb41d30ff9fa'
AND (
token = 'yZ9d8kOAdreQLnwMOWyfR7fuc50iN1ywLhHy8TXte8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)