In that case, you have to maintain the unique id of all your inserted record separately if you want to update them at a specific time. You can use the key/value store layer which is a good fit: https://unqlite.org/c_api/unqlite_kv_fetch.html
One last thing, could you provide a working snippet of your code. Perhaps you are missing something with your retrieval approach which I must take a look at. You can email me directly via chm at symisc dot net.