select records expiring within the next 30 days - sql statement

data type: timestamp column name: dlExpiryDate

String sql = "SELECT * FROM QUALIFICATION WHERE dlExpiryDate >= NOW() AND dlExpiryDate < NOW() + INTERVAL 1 MONTH";

Tried numerous amounts of queries to get the answer but its not working. Anyone got a answer to solve this. Got an example I tried above but it doesnt work. Anyone got an answer to this please? Thanks