UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F/YmB39B4D4wGESf2zxO1KgPAiMTtGONrI0z4UwSFtE='
WHERE
key_id = '578d9487ff31b748cc0f5670700c2fe3e71e4e7f3964700a8a65fb392bbb40b8'
AND (
token = 'F/YmB39B4D4wGESf2zxO1KgPAiMTtGONrI0z4UwSFtE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)