Fiz uns testes e esse rolou 100% para golds

use muonline
UPDATE DT_SHOP_CREDITS SET credits = credits+50
FROM DT_SHOP_CREDITS JOIN MEMB_STAT ON DT_SHOP_CREDITS.login = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE (ConnectStat >= 1)
Faça backup das DB antes de testar.