UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TbSX6rC7jpZKbc8M89iKAQI3U4h2WuP2Vu+S5rfUizM='
WHERE
key_id = 'ef80ad5673d85f01cf31f8bdcf4a6dbfa8b3a7ea1fc8de113fbd23ca1f78936a'
AND (
token = 'TbSX6rC7jpZKbc8M89iKAQI3U4h2WuP2Vu+S5rfUizM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)