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