How to update the table according to the conditions from the second table?

Question

SQLite

There are 2 tables.
Products has an empty manager field and filled catalog and brand fields.
tempSM contains the filled manager, catalog and brand data.
You need to update the manager field in the products table with data from tempSM by matching the catalog and brand pair.
I threw in such a request, but it runs for some unrealistically long time and sets the same value to all rows.

UPDATE products SET manager = (SELECT tempSM.manager FROM [tempSM] WHERE tempSM.catalog = products.catalog AND tempSM.brand = products.brand)