sql查询到期前多少天的订单数据

 select *
        from my_product
        where product_type = 1
        and status = 36
        and TIMESTAMPDIFF(DAY, NOW(), date_add(eff_time, interval 30 day)) = #{days,jdbcType=INTEGER}