Using datetime.now() without timezone information can lead to inconsistencies when comparing timestamps across different systems

[obervinov]

Using datetime.now() without timezone information can lead to inconsistencies when comparing timestamps across different systems or when the database uses timezone-aware timestamps. Consider using datetime.now(timezone.utc) or datetime.utcnow() for consistency with the PostgreSQL NOW() function which returns UTC time by default.

Originally posted by @Copilot in #78 (comment)