How to update Blob data in users table?
It's a serialised PHP array.

You would, in my humble opinion, be nuts to try to parse this with SQL.

Use PHP to unserialize, make your changes, serialize it again, and write the result to the database.