UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'N6Ez8jf8dK7sDS+RY5wMKAKe4lEikZDJY1tKIcdvqTo=' 
WHERE 
  key_id = 'baabbfa461991fcadd114ea4746b03641de1283bd05ce9c14103d9beef6a6dbd' 
  AND (
    token = 'N6Ez8jf8dK7sDS+RY5wMKAKe4lEikZDJY1tKIcdvqTo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027