UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'THHXYTzgSsnbQoIizEcZP+tw9t77NsaJYf9jOlimJWY='
WHERE
key_id = 'ab6265c461857ab495f6b73c51d74c372b0f6ae68cd9c4f05e04cfd98138e9bb'
AND (
token = 'THHXYTzgSsnbQoIizEcZP+tw9t77NsaJYf9jOlimJWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)