UPDATE 
  cscart_cp_blog_posts 
SET 
  viewed = viewed + 1 
WHERE 
  post_id = 4

Query time 0.00055

Result

int(1)