set expiry using sql queries as expiry is set to null

can we append any tables /fields in this backupset database? somehow a tool set retention of backups to 1970, we want to change the retention in expiry_date column for 50 databases