feat: prune the `notifications` table in a weekly interval

We are using the `notifications` table just for the idempotency, so the table can be pruned once a week to clean the database space.
Full context: https://walletconnect.slack.com/archives/C03SPNLG39P/p1706209564977319