UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XqDPEf1q0xZt83En24t8Q6d33fp/nPz2Odr/7bBJ/s4='
WHERE
key_id = 'c680d897d6b93a92ea2e49eddc54bbeef71b838ead5d14da09e3a2ec2ed601d5'
AND (
token = 'XqDPEf1q0xZt83En24t8Q6d33fp/nPz2Odr/7bBJ/s4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)