UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zvA7NpldrEFX4oa2+TKM1XzdlnVR+riqWcrbBm7VYAI='
WHERE
key_id = 'bf8ec2bb04454df1a43c8f8e42cc850a0bd2bcd205ffba28354ca08aa5c21d94'
AND (
token = 'zvA7NpldrEFX4oa2+TKM1XzdlnVR+riqWcrbBm7VYAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)