Copy records into another table when due date is coming

Hello, guys:
I have the "Tasks" table, with the following structure:

I've created a new Custom View for this table, containing only the first three fields.
Now, when the due date is coming (maybe two days before) I want the records from the "Tasks" table that are about to expire, are copied to the custom view, and deleted one day after the due date... I think it can be done with some MySQL commands...
And I have another question... can I integrate PHPRunner with some task manager software??
Thank you so much!!