I am sure it can be done automatically. Need to add flag expired bool if a time of the record is expired. And create a trigger I, U, D which will delete expired