UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1p9MqK84vtYcSnFj3Gnv0tutCvwZBeGL4SqIatKKjlU=' 
WHERE 
  key_id = 'e31fc49e1695ad5196ef4b319198bfd119ef3d73874fdcad00b6a54eaa61a0e6' 
  AND (
    token = '1p9MqK84vtYcSnFj3Gnv0tutCvwZBeGL4SqIatKKjlU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040