UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHDhifHNl8tHuilbPg2i3ygIQqj5U69MlzhTqT0gVRw='
WHERE
key_id = '3342e2de2c6b18f2fa1f1004b13d920eb4ab9926963852883145569cc9a57abc'
AND (
token = 'pHDhifHNl8tHuilbPg2i3ygIQqj5U69MlzhTqT0gVRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)