Update with Left Join

UPDATE actor.usr
SET card = NULL
FROM actor.usr usr2
LEFT JOIN actor.card
ON usr2.card = card.id
WHERE usr2.id = usr.id
AND NOT usr.deleted AND usr.active
AND usr.profile IN (SELECT id FROM permission.grp_descendants(2))
AND usr.card IS NOT NULL
AND card.id IS NULL