What I am trying to do here is adding an
30 DAYS to the
timestamp when the session key was created.
SELECT * FROM `sessions` WHERE (`timestamp` + INTERVAL 30 DAY) <= UTC_TIMESTAMP()
And then checking it to the current time.
But this doesn't work because the session was created just a few days ago. So the
timestamp is way larger than
UTC_TIMESTAMP (the current time).
I can ADD another condition
AND (timestamp + INTERVAL 30 DAY) >= UTC_TIMESTAMP(), but I would have to calculate the interval again.
Is there a more efficient way to have this done?