UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NTrT/CZUGDHUSEj8HvktVUhIPcyCeLck8J4sxG5itTU='
WHERE
key_id = 'd518722dc17d0901aa60eb63bbcde9f25c031db63f8bcf41089fbcc432aa929e'
AND (
token = 'NTrT/CZUGDHUSEj8HvktVUhIPcyCeLck8J4sxG5itTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)