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