UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FCrjja8y/3ihyenoM+Rc4mB2p5hasVI01eneEJVnsis=' 
WHERE 
  key_id = '9b734b2aad74fa0d23547b2492d6604e12636848f6af32bf293ddbb75107782b' 
  AND (
    token = 'FCrjja8y/3ihyenoM+Rc4mB2p5hasVI01eneEJVnsis=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041