UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XE8rQ6bwW18d71Ycs9BXCJHyFtVY4NsfxOZ9RslrJwc='
WHERE
key_id = '7bfaaaffdc13fc77806f391f9c9d0931454fbc48c20d562c6ae3ab2fad7ae3d2'
AND (
token = 'XE8rQ6bwW18d71Ycs9BXCJHyFtVY4NsfxOZ9RslrJwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)