UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xNJHMZC9/JAtv00NUWWdbkjTJ1vyfZfzuvWuN+E/eLY='
WHERE
key_id = 'd9fefa616087cc95252c0ea30c36c1628d142285b95f2ec7930ce9170635c666'
AND (
token = 'xNJHMZC9/JAtv00NUWWdbkjTJ1vyfZfzuvWuN+E/eLY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)