The trigger is fine, you’ll just need to use another module to update a third column with the special now date variable so you can sort by oldest first using the trigger module.
Alternatively, you can just get all the rows, aggregate to an array, and pick a random one.