UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'os3lwZsoJHDsTVBReCpwnr0SXAqcIZqhjbGsnv9AVuY='
WHERE
key_id = 'cc6cdc3dc8e23d3cc2becc1c4a058c37062c4bdb33f14b88b0954d9a9fc47cdf'
AND (
token = 'os3lwZsoJHDsTVBReCpwnr0SXAqcIZqhjbGsnv9AVuY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)