You may wish to re-examine what triggers do:
CREATE TRIGGER (Transact-SQL)[
^]
Therefore, based upon what you wish to do a trigger is not the correct tool. As per the suggestion, above, you really need a job that runs nightly
Some alternatives (
not best practices!):
You may wish to define a function and retrieve the value with the function so that it returns 0 when the value expires.