12.7 Date and Time Functions - MySQL

This means that multiple references to a function such as NOW() within a single query always produce the same result.

dev.mysql.com