between valore_minore AND valore_maggiore

quindi:

BETWEEN CURDATE() - INTERVAL 30 DAY AND CURDATE()