[iiNzTicTx]

Try the following

UPDATE houses AS h INNER JOIN players AS p ON p.Name = h.Owner
SET h.Owner = 'The State', h.Owned = 0
WHERE NOW() >= DATE_ADD( p.LastLogin, INTERVAL 7 DAY );