Fixed #23420 - broken warning for unbound naive datetime objects

Fixes issue with warning message displayed for unbound naive datetime objects when `USE_TZ` is True. Adds unit test that demonstrates the issue (discoverable when using a custom lookup in MySQL) and clarifies docs.

Ticket [#23420](https://code.djangoproject.com/ticket/23420)
can you use "timestamp" as the name instead of an abbreviation?