Context

During the DST to standard time change, when the SQL server is running in a local time zone, records cannot be found when expires_at is set to 1 hour.

Given a PST time and a fallback to standard time at 2 AM, 1 hour from 1 AM, is going to be still 1 AM. The date s converted to the same date that was entered and few seconds after the record cannot be found again.

The expires_at column should be timezone agnostic, possible solution would be to store it as an integer (epoch time),