UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xCMaGEyJ+C5YjHJfNKdMP1OsYv1sPbWP4Ju2Pi71POY='
WHERE
key_id = 'a8995a45f9111cd8a346d5121d7175a5c93ed6998e17ef04f591f9489cc003f5'
AND (
token = 'xCMaGEyJ+C5YjHJfNKdMP1OsYv1sPbWP4Ju2Pi71POY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)