MYSQL: Dates anniversaire de maintenant, à dans 4 mois (prestashop)

gistfile1.sql

$nbDays = 30;

$query = '
		SELECT DISTINCT c.id_customer, firstname, lastname, email
		FROM '._DB_PREFIX_.'customer c
		  
		LEFT JOIN 
		  '._DB_PREFIX_.'orders o ON (c.id_customer = o.id_customer)
	
		WHERE 
			o.valid = 1
		AND 
		    datediff( MAKEDATE( YEAR(NOW()) , DAYOFYEAR(birthday) ) , NOW())    BETWEEN 0 AND '.$nbDays.'
		OR  datediff( MAKEDATE( YEAR(NOW())+1 , DAYOFYEAR(birthday) ) , NOW())  BETWEEN 0 AND '.$nbDays.';';