I think with some modifications to original fileds that you have and taking care in the date format you can try the below script.
//First create a snapshot of 30 days data and store in QVD, this step is one time only.
//Load time_id, ctry,prod from table table1 where time_id>=Today()-30;
//Store Last30daysTranData into Last30daysTranData.QVD;
//Please uncomment the above code and comment everyhting else to create a snapshot
//Once you created the above snapshot, load data from QVD
//any data beyond 30 days will not be loaded
Load * from Last30daysTranData.QVD where time_id>=Today()-30;
//this will append incremental data which is not there in above QVD
Load time_id, ctry,prod from table databasetable where time_id>=Today()-30;
Store Last30daysTranData into Last30daysTranData.QVD;