UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NHTxjprVAXrqfAYfvAm6TebO2mf11eLM2+k3Tta79LU='
WHERE
key_id = '427c8829d36f0e57b651de06c3a7392c44bd4893665e3095474486cea104a13a'
AND (
token = 'NHTxjprVAXrqfAYfvAm6TebO2mf11eLM2+k3Tta79LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)