select * from your_tablewhere year(Start_Date) = year(curdate())and month(Start_Date) = month(curdate())and end_date <= curdate() + interval 30 day

select * from your_tablewhere year(Start_Date) = year(curdate())and month(Start_Date) = month(curdate())and end_date <= curdate() + interval 30 day