How to Sync WorkList And Notifications

We have worklist and Notifications But when we are getting none actionable Items (Notification that Approval has been approved) the worklist gets marked as approved but the notifications stay as New or unread.

Is there a process to clean or set a notification to read once the worklist is read or flagged as read.. and Visa Vera.

I have tried the Below SQL but feel there should be a better way ..

For Notifications

UPDATE PSPTPN_MSG_TBL X

SET    PTPN_MSG_STATE = 'Dismiss'

WHERE 

X.PTPN_MSG_STATE <> 'Dismiss'

                      AND X.PTPN_CATEGORY_TYPE = 'FYI'

                      AND X.PTPN_EVENTNAME = 'AWE'