UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zt1FPLUXYGBqhF43V1I2WOxhVSc3g4n6GsNfkaep02s='
WHERE
key_id = '99740cf324148d4af0d1f668edc933e741c438f0cf63699031c9c14ad8689380'
AND (
token = 'Zt1FPLUXYGBqhF43V1I2WOxhVSc3g4n6GsNfkaep02s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)