Run the query. Easiest solution
Otherwise, export archive to a pst.
Disable user for archiving
delete archive
enable user for archiving, create new archive, import pst.
I looked at the query, you could first do a 'select' to see if the value is in the db. As stated, make a backup of the db mentioned, run query.
Regards. Gertjan