UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WKbJOQ7kjreo92gEHTmpcU9RGpCRtRAhwPV0uYHiALs='
WHERE
key_id = 'b24ad0f04ff14d2f0e9a0095d27d4bb7a1552c90f8f3fdf386447910746b7a55'
AND (
token = 'WKbJOQ7kjreo92gEHTmpcU9RGpCRtRAhwPV0uYHiALs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)