UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NpojWl0W8UG68+zxqg8wWjoDbaMjTtOgBuFAI4ORfT4='
WHERE
key_id = 'd1fc51957c0f22df9bb19584847d077bfdb0e455be2d3f5464c61fed4e43d535'
AND (
token = 'NpojWl0W8UG68+zxqg8wWjoDbaMjTtOgBuFAI4ORfT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)