update table using condition I have City and Cars tables and I have this query:

UPDATE City
           Set status='good', 
           marke1=(Select marke2 From Cars 
                   where car_id=123 
                     and city_id is null 
                     and country is null )
           Where person_id=789


Problem is when country or city_id is not null I am still getting status='good' 
           so I want to use the same (city_id is null and country is null) conditions for status but I'm not good enough in conditional statement. Any help please.
You have to join tables like that: (not an actual query)

UPDATE City AS w
  JOIN Cars AS z ON z.id = w.car_id -- some real condition needed
   SET w.status='good'
 WHERE z.car_id=123 
   AND w.city_id IS NULL 
   AND w.country IS NULL
   AND w.person_id=789
;


Show your tables for more specific code.