For questions like this, it is always worth taking a look in the manual first. Date and time functions in the mySQL manual
CURDATE() returns the DATE part of the current time. Manual on CURDATE()
NOW() returns the date and time portions as a timestamp in various formats, depending on how it was requested. Manual on NOW().