add redeemed at time and methods to query