How to get the timestamp of one day back using NOW() call
Use an expression like:
timestampadd(SQL_TSI_DAY, -1, NOW())