In the documentation for the NOW() function it states that:
If the base is closed, it will update approximately every hour only when the base has time-dependent automation triggers or actions, or sync dependencies.
I have a Zapier process that poll...